select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Elegant Purple Ball Gown Sweetheart Taffeta Sash Dress for Quince
Dark Purple Sweetheart Pick-ups Quinceanera Dresses with White Bow
Best Lilac Ball Gown Sweetheart Multi-tiered Quinceanera Gown
Grass Green Spaghetti Straps Ruched Quince Dresses with Ruffles
Spring Green Sweetheart Pleated Embroidery Beading Quince Dresses
New Arrival Orange Taffeta Strapless Pick-ups Dress for Sweet 15
Coral Red Strapless Appliques Ruffles Hand Made Flower Quince Dresses
New Colorful Strapless Appliques and Ruffles Sweet 15 Dresses
Black and Green Beaded and Embroidery Decorate Quince Dresses
Multi-Color Strapless Beading Ruches Puffy Quinceanera Dresses
Popular Colorful Ruffled Layers and Appliques Quinceanera Gown
Best Puffy Pink Strapless Dress for Sweet 15 with Flora Appliques
Colorful off the Shoulder Pick-ups Lace Decorate Sweet 15 Dresses
Sweetheart Hand Made Flowers Ruffled Quinceanera Dresses
Strapless Taffeta Pleats and Appliques Beading Dress for Quince
Colorful Ball Gown Strapless Organza Beading Sweet 15 Dresses
Dark Grey Floor-length Organza Appliques Sweet Sixteen Dresses
Popular Royal Blue Floor-length Organza Dresses for Quince
Yellow Floor-length Organza Appliques Dress for Quinceaneras
Green Strapless Organza Dress for Quinceanera with Appliques
Purple Floor-length Taffeta Appliques Dress for Quince
Discount Sweetheart Taffeta Dress for Quince with Appliques
Red Taffeta Appliques Floor-length Quinceanera Dresses
Two Toned Taffeta Dress for Quinceaneras with Pick Ups
Lovely Yellow Green Beaded Dress for Quince with Ruffles
Purple and Leopard Taffeta Dress for Quince with Ruffles
Yellow Floor-length Taffeta Pick-ups Dress for Quinceaneras
Black and Olive Green Organza Sweet 16 Dresses with Appliques
White Organza Beaded Sweet Sixteen Dresses with Train
Beaded One Shoulder Taffeta and Organza Flowers Quince Dress